import sqlite3

connect = sqlite3.connect("/Users/cai/Documents/databases/sqlite/baiwan.sqlite")

transaction = connect.in_transaction

for i in range(1000000):
    connect.execute("insert into test_table (name_id, name) values (?, ?);", (i % 100, str(i)))
    pass

connect.commit()
connect.close()
